HCL
Skip to main content  
 
   


SPRTechnote


Activity Errors Out when Selecting Against MS Access Table with Space in Field Name

Technote Number: 1108384


Problem:
To avoid the error, reformat your syntax to enclose fields with spaces in
brackets. For example, change your syntax to:

SELECT [picture text] FROM PictureTest

This solution also works if you are using ODBC, @dblookup, to gather
information from Microsoft Access to be placed into Notes when you encounter
spaces and/or dashes.
More >





  Document options
Print this document
Print view

  Search
Search Advanced Search


  Fix list views

 RSS feeds   RSS
Subscribe to the fix list

  Resources
Using this database
View notices

  HCL Support
HCL Support


    About HCL Privacy Contact